My SQL

How To Connect To MySql Database
mysql -uroot -pcloudera
NOTE: Here password is XXXXXX
TO SEE THE AVAILABLE DATABASES
mysql> show databases;
mysql > create database dwdev;
TO SEE AVAILABLE TABLES
mysql> show tables;
TO CREATE A TABLE IN MYSQL
mysql> use dwdev;
mysql> create table emp(empid int primary key,ename varchar(50),esal int, deptid Varchar(20));
Query OK, 0 rows affected (0.00 sec)

TO INSERT THE DATA INTO TABLE

mysql> insert into emp values(100,'EMP1',12000,'00A1');
insert into emp values(101,'EMP2',13000,'00A2');
insert into emp values(102,'EMP3',14000,'00A2');
insert into emp values(103,'EMP4',15000,'00A1');
insert into emp values(105,'EMP5',16000,'00A1');

Query OK, 1 row affected (0.00 sec)
NOTE: insert multiple records in the same way like above
mysql> create table empdetails(id int,name varchar(50),sal int,address varchar(50));
Query OK, 0 rows affected (0.00 sec)
OTHER TABLES CREATION & DATA INSERTION
mysql> insert into empdetails VALUES (100,'Raju',12000,'Hyd'), (101,'Ravi',14000,'Pune'),(102,'Ramya',15000,'Chn'),(103,'Ranga',16000,'Bang');
mysql> create table dept(deptid Varchar(20) ,dname varchar(50),dloc varchar(60));
Query OK, 0 rows affected (0.00 sec)
mysql> insert into dept VALUES ('00A1','HRD','HYD'),('00A1','TRANSPORT','BAN'),('00A1','R&D','CHN'),('00A2','ADMIN','HYD'),('00A2','SALES','PUNE'),('00A4','FINANCE','MUM'),('00A2','MARKETING','HYD');
mysql> create table student(sid int primary key,name varchar(50),age int,marks int);
Query OK, 0 rows affected (0.00 sec)
mysql> insert into student VALUES (1,'ABHIRAM',21,80),(2,'BHAVYA',23,90),(3,'CHAITU',28,67),(4,'ESWAR',22,91);